CREATE TABLE IF NOT EXISTS player (
id INT(11) NOT NULL AUTO_INCREMENT,
user_name VARCHAR(20) DEFAULT NULL,
pword LONGTEXT DEFAULT NULL,
last_connection DATETIME DEFAULT NULL,
last_time DATE DEFAULT NULL,
map INT(8) DEFAULT NULL,
map_loc INT(8) DEFAULT NULL,
character_a VARCHAR(20) DEFAULT NULL,
character_b VARCHAR(20) DEFAULT NULL,
creation_time DATE DEFAULT NULL,
p_power INT(4) DEFAULT NULL,
p_skill INT(4) DEFAULT NULL,
p_health INT(4) DEFAULT NULL,
p_base_health INT(4) DEFAULT NULL,
p_modifier INT(4) DEFAULT NULL,
PRIMARY KEY (id) 
) ENGINE=InnoDB

CREATE TABLE IF NOT EXISTS mapper (
id INT(8) NOT NULL AUTO_INCREMENT,

map INT(8) DEFAULT NULL,
map_loc INT(8) DEFAULT NULL,
mapname VARCHAR(20) DEFAULT NULL,
roomname VARCHAR(20) DEFAULT NULL,
type INT(4) DEFAULT NULL,

PRIMARY KEY (id) 
) ENGINE=InnoDB

CREATE TABLE IF NOT EXISTS mobile (
id INT(11) NOT NULL AUTO_INCREMENT,
user_name VARCHAR(20) DEFAULT NULL,
desc LONGTEXT DEFAULT NULL,
mode INT(8) DEFAULT NULL,
map INT(8) DEFAULT NULL,
map_loc INT(8) DEFAULT NULL,
character_a VARCHAR(20) DEFAULT NULL,
character_b VARCHAR(20) DEFAULT NULL,
creation_time DATE DEFAULT NULL,
p_power INT(4) DEFAULT NULL,
p_skill INT(4) DEFAULT NULL,
p_health INT(4) DEFAULT NULL,
p_base_health INT(4) DEFAULT NULL,
p_modifier INT(4) DEFAULT NULL,
PRIMARY KEY (id) 
) ENGINE=InnoDB
